package com.czxy.dao;

import com.czxy.domain.DownLoad;
import org.apache.ibatis.annotations.Result;
import org.apache.ibatis.annotations.Results;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface DownLoadMapper {
    @Select("select * from upload")
    public List<DownLoad> findAllVideo();

    @Select("select * from upload")
    @Results({
            @Result(property = "username",column = "user")
    })
    public List<DownLoad> findAllVideo02();

    @Select("select videoAddress from upload where videoId=#{videoId}")
    public String findVideoAddressById(String videoId);
}
